garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Hi,
I have having a bit of an issue with a formula.
My raw data file I have downloaded appears as text format when there is a 0, 00 prefix or if there is a letter prefix.
However, if there is a standard number then it formats this as a number (natural). My look up file is based only on text format. And so I need a formula to convert the number to text.
Looking on the internet this gives a very basic =TEXT(Cell,"0"). However, when this is appllied to a cell which has a 0, or 00 then it keeps the text format, but removes the 0's
What formula can I use? As you can see below it has converted X90 to text in Y90 (But in Y89 it has removed the 00 which I dont want)
I have having a bit of an issue with a formula.
My raw data file I have downloaded appears as text format when there is a 0, 00 prefix or if there is a letter prefix.
However, if there is a standard number then it formats this as a number (natural). My look up file is based only on text format. And so I need a formula to convert the number to text.
Looking on the internet this gives a very basic =TEXT(Cell,"0"). However, when this is appllied to a cell which has a 0, or 00 then it keeps the text format, but removes the 0's
What formula can I use? As you can see below it has converted X90 to text in Y90 (But in Y89 it has removed the 00 which I dont want)