Excel 97 automatic cell format

S

Stef

Hi,

I have a problem with one of my users under Excel 97,
when he put the 01.02.03 value in a cell with
the "general" format, Excel change the cell format
to "Date"... but we do not want it to be a date. It is
not doing that under other Excel version (2002, XP...)
only on 97

Help on that would be appreciate

Many thanks
 
R

Ron de Bruin

Hi Stef

I think the only way is to format the cell as text before you type 01.02.03
Or type '01.02.03 , you don't see the ' in the cell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
Formatting automatically filled cells 3
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
International Date formatting 6
Worksheet Change in Excel 97 does not run first time 4
conditional format - table - cell empty return default color 1
Excel 97 replace vs newer versions... 2

Top