Using TEXT Function in Excel

[Melwyn Fernandes]

Hi,
I want to insert a value "02-03" into a cell.
However, EXCEL treats this value as a DATE value
and converts the same to 02-Mar.

In Windows NT we handled this problem by using the
the following function.
=TEXT("02-03","00000")

On migrating to Windows XP, this cell formatting
fx has gone for a toss. The value displayed in the
cell is 38048.

Please help me out with this. I need to use the TEXT
fx itself.

Regards
Melwyn

 

[Leo Heuser]

Hi Melwyn

One way is to enter a single apostrophe '
prior to entering "02-03" (without quotes)

Another way is to format the cell as "Text"
*prior* to entering "02-03" (without quotes)

 

[Ron de Bruin]

Hi Melwyn

No need for a formula
Why don't you type a apostrophe before it?

'02-03

Or format your cell as text before you enter the date

 

[Bob Phillips]

Melwyn ,

These work

'02-03

that is preceded by an apostrophe

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Vaughan]

Hi
What effect are you looking for? If you just want to display 02-03 (without the quotes) then you can simply enter '02-03 - ie start it with an apostrophe OR format the cells as text and enter 02-03. If you want the quotes then just enter it that way ie "02-03".

Does any of this help?