Input a number to not display as a date

  • Thread starter Ms Veco Indiana
  • Start date
M

Ms Veco Indiana

hello! I have ran into this problem a few times when I'm trying to get a
number to appear, i.e. 3-30, and it automatically changes it into a date,
30-Mar.

I've gone in and formatted and reformated the cell as a general number and
it automatically changes back to date....errrrrrrrr.
 
A

Alan

Enter it with a preceding apostrophe, '3-30. The apostrophe will show in the
formula bar but not in the cell,
Regards,
Alan.
 
M

Ms Veco Indiana

Thanks! I knew it was something like that! I'd tried " and ^ from Quattro,
but they kept appearing!

Thanks!
 

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

Top