successone
New Member
- Joined
- Jul 7, 2003
- Messages
- 30
I have the following formula:
=CONCATENATE(B28,0)
In B28 is the following text(formated as text):000143
so I want the result to be: 0001430
I have used the fx button to make sure syntax is correct and cell is formated as text, but we only see the formula, not the result.
What can we do?
=CONCATENATE(B28,0)
In B28 is the following text(formated as text):000143
so I want the result to be: 0001430
I have used the fx button to make sure syntax is correct and cell is formated as text, but we only see the formula, not the result.
What can we do?