Osvaldo Palmeiro
Well-known Member
- Joined
- Feb 24, 2009
- Messages
- 752
- Office Version
- 365
- Platform
- Windows
Hi, all.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Having trouble with results to convert number to text - Excel 2003.<o></o>
I´m trying to convert, e.g., $1,236.25 to text, by using =TEXT(A1;"0,0.00") and
=MID(A1,1,LEN(A1)).<o></o>
Both ignore and return the same number.<o></o>
<o></o>
Some idea why they do'nt work? Maybe configuration?<o></o>
<o></o>
Thanks in advance.<o></o>
<o></o>
ps – at another PC, with Excel XP, both work fine<o></o>
Having trouble with results to convert number to text - Excel 2003.<o></o>
I´m trying to convert, e.g., $1,236.25 to text, by using =TEXT(A1;"0,0.00") and
=MID(A1,1,LEN(A1)).<o></o>
Both ignore and return the same number.<o></o>
<o></o>
Some idea why they do'nt work? Maybe configuration?<o></o>
<o></o>
Thanks in advance.<o></o>
<o></o>
ps – at another PC, with Excel XP, both work fine<o></o>