Entering data in excel or access 1

[alien66]

when i try to enter Witha in to a cell or in access as soon as i move to next cell it will auto put a space so you get with a is there a reason why .. witha is a short code and format is just text .. any help would be good unable to find on google

 

[SkipVought]

Hi,

Excel and Access act very differently. An Access Text field CAN be defined as Fixed Width, which will pad spaces.

This does NOT happen in Excel. Please explain how you feel this is happening.





Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[alien66]

try typing witha into a cell in excel and wehn you move to the next cell the space is put in same as in access

 

[SkipVought]

Please copy several cells that you have entered data in and paste here.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

I suspect (but can't be sure due to the lack of details in the question) that the problem is that Office is auto-correcting "witha" to "with a".

You could go into AutoCorrect options and disable that particular entry.

If you'd like help finding that in the menus, please tell us what version of office are you running? (2003, 2007 etc.)



[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Ahhhh, John. You hit it! I focused on the excessive SPACES in this segment

so you get with a is there a reason why

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[alien66]

it is the autocorrect I over look that cheers for that

 

[AnotherHiggins]

Glad we could help!



[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.